SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO



CREATE PROCEDURE [dbo].[usp_SearchStudent]
    (
      @fdStudNo VARCHAR(50),
      @fdStudName VARCHAR(50),
      @fdStudSpec VARCHAR(50)
    )
AS 
    SELECT  fdStudNo,
            fdStudName,
            fdStudCollege,
            fdStudSpec,
            fdStudPhone,
            fdStudHomeTel
    FROM    dbo.FS_Student
    WHERE   ( fdStudNo LIKE '%' + @fdStudNo + '%' )
            AND ( fdStudName LIKE '%' + @fdStudName + '%' )
            AND ( fdStudSpec LIKE '%' + @fdStudSpec + '%' )



GO
